Financial Statement Column Formats

OBJECTIVE

The Financial Statement Column Formats function is used to define the columns to be printed on the financial statement (only the month, preceding year, budget, ratio, etc.).

PREREQUISITEs

STEPS

maestro* > Accounting > Financial Management > Financial Statements > Financial Statement Column Formats

Create a column format

The Display Predefined Formats function contains all of the basic formats in the system.

Enter a Description to identify the format created.
Enter the required information:

The numbers 1, 2, 3, 4, etc. identify the columns on the financial statement.

Field

Description

Input the masks at run time

When this format is used, asks the user to select masks when printing the financial statement if the box is checked.

Variable

Variable to be used for this column.

NOTE: The variables displayed can be those provided by the system or those defined by the user with the Financial Statement Variables option.

Alignment

Alignment of descriptions in the column.

Fr. Desc.

French description of the column.

NOTES: The column description can be changed manually.

You can select a period as a column header by double clicking on this field in the desired column.

This field is displayed based on the choices checked in the configuration options of Financial Statement Configuration.

Eng. Desc.

English description of the column.

NOTES: The column description can be changed manually.

You can select a period as a column header by double clicking on this field in the desired column.

This field is displayed based on the choices checked in the configuration options of Financial Statement Configuration.

Formula

Used to enter a specific formula for the column.

NOTES: This field is conditional on use of the FORMULA variable.

You can develop a formula using the variables and mathematical operators available in the system by double clicking in the desired column of this field.

Ratio: Use Column

Identifies the number of the column used to calculate the ratio.

NOTES: For example, 1.

This field is conditional on the use of the RATIO or RATIO/100 variables.

The ratio is calculated based on the information in the Ratio/UP fields. Create ID and Ratio: Use ID from Financial Statement Configuration.

UP: Use Column Amt

Identifies the column number that contains the amount that must be used to calculate the unit price.

NOTE: This field is conditional on the use of the UP variable. The variable is available only if the Quantity Management in G/L function is activated in Configuration, General tab.

UP: Use Column Qty

Identifies the column number that contains the quantity that must be used to calculate the unit price.

NOTE: This field is conditional on the use of the UP variable. The variable is available only if the Quantity Management in G/L function is activated in Configuration, General tab.

Font

Font, style and size used for the column header.

Symbol

$ or %, before or after the value.

Prefix Mask

Lets you select a prefix mask to be used to calculate the result of the column by double clicking the field.

Project Mask

Lets you select a project mask to be used to calculate the result of a column by double clicking the field.

Activity Mask

Lets you select an activity mask to be used to calculate the result of a column by double clicking the field.

Group Mask

Lets you select a group mask to be used to calculate the result of a column double clicking the field.

Department Mask

Used to select a department mask to be considered to calculate the result for the line by double clicking the field.

Master Project Mask

Used to select a master project mask to be considered to calculate the result for the line by double clicking the field.

Project Type Mask

Lets you select a project type mask to be used to calculate the result of a line by double clicking the field.

Category Mask

Used to select a mask for the category to be considered to calculate the result for the line by double clicking the field.

Invisible

If the box is checked it prevents the display of the column if it is only used to perform calculations.

Enter the masks as required:

WARNING! If the Request masks when printing field is checked (to the right of the description), this section will not be available.

Field	Description
Input the masks at run time	When this format is used, asks the user to select masks when printing the financial statement if the box is checked.
Variable	Variable to be used for this column. NOTE: The variables displayed can be those provided by the system or those defined by the user with the Financial Statement Variables option.
Alignment	Alignment of descriptions in the column.
Fr. Desc.	French description of the column. NOTES: The column description can be changed manually. You can select a period as a column header by double clicking on this field in the desired column. This field is displayed based on the choices checked in the configuration options of Financial Statement Configuration.
Eng. Desc.	English description of the column. NOTES: The column description can be changed manually. You can select a period as a column header by double clicking on this field in the desired column. This field is displayed based on the choices checked in the configuration options of Financial Statement Configuration.
Formula	Used to enter a specific formula for the column. NOTES: This field is conditional on use of the FORMULA variable. You can develop a formula using the variables and mathematical operators available in the system by double clicking in the desired column of this field.
Ratio: Use Column	Identifies the number of the column used to calculate the ratio. NOTES: For example, 1. This field is conditional on the use of the RATIO or RATIO/100 variables. The ratio is calculated based on the information in the Ratio/UP fields. Create ID and Ratio: Use ID from Financial Statement Configuration.
UP: Use Column Amt	Identifies the column number that contains the amount that must be used to calculate the unit price. NOTE: This field is conditional on the use of the UP variable. The variable is available only if the Quantity Management in G/L function is activated in Configuration, General tab.
UP: Use Column Qty	Identifies the column number that contains the quantity that must be used to calculate the unit price. NOTE: This field is conditional on the use of the UP variable. The variable is available only if the Quantity Management in G/L function is activated in Configuration, General tab.
Font	Font, style and size used for the column header.
Symbol	$ or %, before or after the value.
Prefix Mask	Lets you select a prefix mask to be used to calculate the result of the column by double clicking the field.
Project Mask	Lets you select a project mask to be used to calculate the result of a column by double clicking the field.
Activity Mask	Lets you select an activity mask to be used to calculate the result of a column by double clicking the field.
Group Mask	Lets you select a group mask to be used to calculate the result of a column double clicking the field.
Department Mask	Used to select a department mask to be considered to calculate the result for the line by double clicking the field.
Master Project Mask	Used to select a master project mask to be considered to calculate the result for the line by double clicking the field.
Project Type Mask	Lets you select a project type mask to be used to calculate the result of a line by double clicking the field.
Category Mask	Used to select a mask for the category to be considered to calculate the result for the line by double clicking the field.
Invisible	If the box is checked it prevents the display of the column if it is only used to perform calculations.

Masks are used to filter transactions to include only those that match the desired criteria.

All mask entries must be created manually. You cannot search on these fields.

The composition of masks and the meaning of symbols to be used are available in the appendix.

To define a mask, double-click on one of the mask lines. A window is displayed in which you can enter information for the mask.

Field

Description

Template

Name of the template.

NOTE: You can save all of the values entered in masks in a Template. This prevents you from having to enter each of the values manually when you want to apply the same masks to multiple print formats. To do this, click the Save this Template icon. You will be able to open the template later when you are defining another column or another print format, or when you use the Print Financial Statements option if the Request masks when printing field is checked.

Title

Title to be displayed on the financial statements.

NOTE: This title will be accessible to the variables available when defining headers and footers for financial statements. It will only be available if masks are selected during printing.

Company Identification

Used to specify the filter to be applied to the Prefix field.

NOTE: This information is also visible in the print format configuration grid, on the Prefix Mask line.

Project

Used to specify the filter to be applied to the Project field.

NOTE: This information is also visible in the print format configuration grid, on the Project Mask line.

Activity Code

Used to specify the filter to be applied to the Activity field.

NOTE: This information is also visible in the print format configuration grid, on the Activity Mask line.

Expense group

Used to specify the filter to be applied to the Group field.

NOTE: This information is also visible in the print format configuration grid, on the Group Mask line.

Department

Used to specify the filter to be applied to the Department field.

NOTE: This information is also visible in the print format configuration grid, on the Department Mask line.

Master Project

Used to specify the filter to be applied to the Master Project field.

NOTE: This information is also visible in the print format configuration grid, on the Master Project Mask line.

Project Type

Used to specify the filter to be applied to the Project Type field.

NOTE: This information is also visible in the print format configuration grid, on the Project Type Mask line.

Project Category

Used to specify the filter to be applied to the Project Category field.

NOTE: This information is also visible in the print format configuration grid, on the Category Mask line.

If masks are specified in these fields, only transactions for which ALL masks specified apply will be included when printing financial statements.

Field	Description
Template	Name of the template. NOTE: You can save all of the values entered in masks in a Template. This prevents you from having to enter each of the values manually when you want to apply the same masks to multiple print formats. To do this, click the Save this Template icon. You will be able to open the template later when you are defining another column or another print format, or when you use the Print Financial Statements option if the Request masks when printing field is checked.
Title	Title to be displayed on the financial statements. NOTE: This title will be accessible to the variables available when defining headers and footers for financial statements. It will only be available if masks are selected during printing.
Company Identification	Used to specify the filter to be applied to the Prefix field. NOTE: This information is also visible in the print format configuration grid, on the Prefix Mask line.
Project	Used to specify the filter to be applied to the Project field. NOTE: This information is also visible in the print format configuration grid, on the Project Mask line.
Activity Code	Used to specify the filter to be applied to the Activity field. NOTE: This information is also visible in the print format configuration grid, on the Activity Mask line.
Expense group	Used to specify the filter to be applied to the Group field. NOTE: This information is also visible in the print format configuration grid, on the Group Mask line.
Department	Used to specify the filter to be applied to the Department field. NOTE: This information is also visible in the print format configuration grid, on the Department Mask line.
Master Project	Used to specify the filter to be applied to the Master Project field. NOTE: This information is also visible in the print format configuration grid, on the Master Project Mask line.
Project Type	Used to specify the filter to be applied to the Project Type field. NOTE: This information is also visible in the print format configuration grid, on the Project Type Mask line.
Project Category	Used to specify the filter to be applied to the Project Category field. NOTE: This information is also visible in the print format configuration grid, on the Category Mask line.

Click Save.

APPENDIX

Meaning of Symbols

The asterisk (*), question mark (?), hash (#), exclamation mark (!), dash (-) and square brackets ([ ]) can be used in queries to include all records, file names or other items starting with the characters specified or to represent similar records.

Symbol	Example	Usage
*	tr* for transportation, transfer, troop *re for dire, tire, fire	Represents any number or character and can be used anywhere in the mask.
?	b?ll for ball, bell	Represents any single character.
#	1#3 for 103, 113, 123	Represents any single number.
[]	b[ae]ll for ball, but not bill	Represents any of the characters within the square brackets.
!	b[!ae]ll for bill, but not ball	Represents any character not included between the square brackets.
-	b[a-c]d for bad, bbd, bcd only	Represents any of the characters in the range of characters specified.

Composition of Masks

Mask Type	Example	True	False
Multiple characters	aa ab*	aa, aBa, aBBBa abc, AABB, Xab	aBC aZb, bac
Special characters	a[*]a	a*a	Aaa
Multiple characters	ab*	abcdefg, abc	cab, aab
Single character	a?a	aaa, a3a, aBa	aBBBa
Single number	a#a	a0a, a1a, a2a	aaa, a10a
Range of characters	[a-z]	f, p, j	2, &
Characters not included in the range	[!a-z]	9, &, %	b, a
No numbers	[!0-9]	A, a, &	0, 1, 9
Grouped	a[!b-m]#	An9, az0, a99	abc, aj0

Last modification: September 20, 2024